<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of mManageUser
 *
 * @author SG10015
 */


$q = isset($_POST['q']) ? strval($_POST['q']) : '';
$sql = "SELECT PCKG_ID,PCKG_DESC,PCKG_ACTIVE,CREATED_DATE,CREATED_BY,CHANGED_DATE,CHANGED_BY FROM trv_package WHERE 1=1 AND PCKG_ACTIVE='1' AND PCKG_DESC like '%".$q."%'";
//echo $sql;
$rs = @mysql_query($sql);
$rows = array();
while($row = @mysql_fetch_assoc($rs)){
	$rows[] = $row;
}
echo json_encode($rows);
?>
